Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DBA_LOGSTDBY_PROGRESS

`DBA_LOGSTDBY_PROGRESS` displays the progress of log apply services on the logical standby database. This view is for logical standby databases only.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`APPLIED_SCN` | `NUMBER` |  | Newest SCN at which all changes have been applied. The values in the `APPLIED_SCN` and `NEWEST_SCN` columns will match if all available redo log data has been processed.
`APPLIED_THREAD#` | `NUMBER` |  | Thread number for the log file containing the `APPLIED_SCN`
`APPLIED_SEQUENCE#` | `NUMBER` |  | Sequence number for the log file containing the `APPLIED_SCN`
`APPLIED_TIME` | `DATE` |  | Estimate of the time and date of the `APPLIED_SCN`
`READ_SCN` | `NUMBER` |  | All log data less than this SCN has been read and saved
`READ_THREAD#` | `NUMBER` |  | Thread number for a log file containing the `READ_SCN`
`READ_SEQUENCE#` | `NUMBER` |  | Sequence number for a log file containing the `READ_SCN`
`READ_TIME` | `DATE` |  | Estimate of the time and date of the `READ_SCN`
`NEWEST_SCN` | `NUMBER` |  | Most recent SCN available on the standby system. If no more logs are being shipped, then changes could be applied to this SCN. The values in the `APPLIED_SCN` and `NEWEST_SCN` columns will match if all available redo log data has been processed.
`NEWEST_THREAD#` | `NUMBER` |  | Thread number for a log containing the `NEWEST_SCN`
`NEWEST_SEQUENCE#` | `NUMBER` |  | Sequence number for a log containing the `NEWEST_SCN`
`NEWEST_TIME` | `DATE` |  | Estimate of the time and date of the `NEWEST_SCN`

Note: The SCN values shown in this view correlate to the SCN values shown in the `DBA_LOGSTDBY_LOG` view.